Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_204

R_204

ResourceItemKind

ResourceItem

ResourceItemKindID

 

 

R_205

R_205

ResourceItemKind

ResourceItemKindText

ResourceItemKindID

 

 

R_207

R_207

ResourceItem

DrugDetails

ResourceID

 

 

R_269

R_269

DrugForm

DrugDetails

DrugFormID

 

 

R_270

R_270

DrugForm

DrugFormText

DrugFormID

 

 

R_288

R_288

ApplicationWay

LDrugDetailsApplicationWay

ApplicationWayID

 

 

R_292

R_292

DrugValidation

DrugDetails

DrugValidationId

 

 

R_1523

R_1523

StockItem

DrugDetails

StockItemID

 

 

R_1525

R_1525

Frequency

LFrequencyApplicationWay

FrequencyID

 

 

R_1526

R_1526

ApplicationWay

LFrequencyApplicationWay

ApplicationWayID

 

 

R_1527

R_1527

ResourceItem

LResourceItemFormulary

ResourceID

 

 

R_1528

R_1528

Formulary

LResourceItemFormulary

FormularyID

 

 

R_1530

R_1530

Formulary

LOrgUnitFormulary

FormularyID

 

 

R_1544

R_1544

DrugDetails

LDrugDetailsApplicationWay

DrugDetailsID

 

 

R_1556

R_1556

TherapyGroup

DrugDetails

TherapyGroupID

 

 

R_2060

R_2060

ResourceItemKind

LSysFctResourceItemKind

ResourceItemKindID

 

 

R_2061

R_2061

SysFct

LSysFctResourceItemKind

SysFctID

 

 

R_2062

R_2062

SysFct

LSysFctResourceItemKind

Sys_SysFctID

 

 

R_2486

R_2486

PhSt

PhAccPeriodSumm

StPlaceID

 

 

R_2487

R_2487

PhDrugClass

PhAccPeriodSummItem

DrugClassID

 

 

R_2488

R_2488

PhStItemKind

PhAccPeriodSummItem

StItemKindID

 

 

R_2489

R_2489

PhStItemGroup

PhAccPeriodSummItem

StItemGroupID

 

 

R_8884

R_8884

Frequency

LOrgUnitFrequency

FrequencyID

 

 

R_9037

R_9037

StockInvoiceDataLine

StockInvoiceData

StockInvoiceDataLineID

 

 

R_9038

R_9038

StockEntryDocumentItem

StockInvoiceData

StockEntryDocumentItemID

 

 

R_9039

R_9039

StockItem

StockInvoiceData

StockItemID

 

 

R_9040

R_9040

StockEntryDocumentType

StockInvoiceData

StockEntryDocumentTypeID

 

 

R_9041

R_9041

ExternalOrgUnit

StockInvoiceData

ExternalOrgUnitID

 

 

R_9042

R_9042

Unit

StockInvoiceData

TotalSubstanceQuantityUnitID

 

 

R_9043

R_9043

VATRate

StockInvoiceData

VatRateID

 

 

R_9370

R_9370

PhStDocKind

PhStDocAccountDef

StDocKindID

 

 

R_9371

R_9371

PhStDocType

PhStDocAccountDef

StDocTypeID

 

 

R_9656

R_9656

PhLotType

PhStDocAccountDef

LotTypeId

 

 

R_9657

R_9657

PhSt

PhStDocAccountDef

StId

 

 

R_9658

R_9658

PhSt

PhStState

StId

 

 

R_9659

R_9659

PhAccountingPeriod

PhStState

AccountingPeriodID

 

 

R_9660

R_9660

PhInventory

PhStState

InventoryId

 

 

R_9666

R_9666

PhStState

PhStStateItem

StStateId

 

 

R_9667

R_9667

PhLot

PhStStateItem

LotId

 

 

R_9668

R_9668

PhSt

PhStState

StPlaceId

 

 

R_9761

R_9761

PhStState

PhSt

LastStStateId

 

 

R_9960

R_9960

PhSt

PhAccPeriodSumm

StID

 

 

R_9963

R_9963

PhAccPeriodSumm

PhAccPeriodSummItem

AccPeriodSummId

 

 

R_9966

R_9966

PhResourceType

PhAccPeriodSummItem

ResourceTypeID

 

 

R_10146

R_10146

ReceptionaryStatus

ReceptionaryStatusText

ReceptionaryStatusID

 

 

R_10147

R_10147

ReceptionaryStatus

DrugDetails

InReceptionary

 

 

R_10256

R_10256

PhStDoc

PhLStDocInventory

StDocID

 

 

R_10257

R_10257

PhInventory

PhLStDocInventory

InventoryId

 

 

R_10258

R_10258

PhStDocItem

PhInventoryItem

StockDocumentItemId

 

 

R_10259

R_10259

PhInventoryDiffType

PhInventoryDiffTypeText

InventoryDiffTypeID

 

 


2